﻿CREATE TABLE [dbo].[datKonten] (
    [KtoID]           INT            NULL,
    [Kto]             INT            NULL,
    [Bezeichnung]     NVARCHAR (255) NULL,
    [Kontenart]       TINYINT        NULL,
    [Kontenklasse]    TINYINT        NULL,
    [USt-Steuercode]  TINYINT        NULL,
    [Matchcode]       NVARCHAR (255) NULL,
    [USt-Prozentsatz] FLOAT (53)     NULL,
    [Gt]              BIT            NULL,
    [Kg]              BIT            NULL,
    [Kp]              BIT            NULL,
    [Kt]              BIT            NULL,
    [Lc]              BIT            NULL,
    [Mh]              BIT            NULL,
    [Mi]              BIT            NULL,
    [Ms]              BIT            NULL,
    [Na]              BIT            NULL,
    [Pi]              BIT            NULL,
    [Sm]              BIT            NULL,
    [Sv]              BIT            NULL,
    [Tp]              BIT            NULL,
    [Wm]              BIT            NULL,
    [Wp]              BIT            NULL,
    [Za]              BIT            NULL,
    [Zk]              BIT            NULL,
    [Zv]              BIT            NULL,
    [Ef]              BIT            NULL,
    [Og]              BIT            NULL,
    [S1]              BIT            NULL,
    [Tz]              BIT            NULL,
    [Wk]              BIT            NULL,
    [Inhalt]          NVARCHAR (255) NULL,
    [Details]         NVARCHAR (255) NULL,
    [Text]            NVARCHAR (255) NULL
);

